﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsAssignment" targetNamespace="http://tempuri.org/dsAssignment.xsd" xmlns:mstns="http://tempuri.org/dsAssignment.xsd" xmlns="http://tempuri.org/dsAssignment.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString4" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString4 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString4" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentTableAdapter" GeneratorDataComponentClassName="tblAssignmentTableAdapter" Name="tblAssignment" UserDataComponentName="tblAssignmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblAssignment] WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblAssignment] ([nCrewid], [nVesselId], [cStatus], [cDescription], [dEmbarked], [nContract], [dLeave], [nRequest], [dDuKienRoiTau], [dSanSangLenTau], [dCatHopDong], [dNghiHuu], [dKyHopDong], [dModified], [isActive], [cGhiChu]) VALUES (@nCrewid, @nVesselId, @cStatus, @cDescription, @dEmbarked, @nContract, @dLeave, @nRequest, @dDuKienRoiTau, @dSanSangLenTau, @dCatHopDong, @dNghiHuu, @dKyHopDong, @dModified, @isActive, @cGhiChu);
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cGhiChu FROM tblAssignment WHERE (nAssignmentId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cGhiChu FROM dbo.tblAssignment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblAssignment] SET [nCrewid] = @nCrewid, [nVesselId] = @nVesselId, [cStatus] = @cStatus, [cDescription] = @cDescription, [dEmbarked] = @dEmbarked, [nContract] = @nContract, [dLeave] = @dLeave, [nRequest] = @nRequest, [dDuKienRoiTau] = @dDuKienRoiTau, [dSanSangLenTau] = @dSanSangLenTau, [dCatHopDong] = @dCatHopDong, [dNghiHuu] = @dNghiHuu, [dKyHopDong] = @dKyHopDong, [dModified] = @dModified, [isActive] = @isActive, [cGhiChu] = @cGhiChu WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)));
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive, cGhiChu FROM tblAssignment WHERE (nAssignmentId = @nAssignmentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cGhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cGhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nAssignmentId" ColumnName="nAssignmentId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nAssignmentId" DataSetColumn="nAssignmentId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="dSanSangLenTau" DataSetColumn="dSanSangLenTau" />
              <Mapping SourceColumn="dCatHopDong" DataSetColumn="dCatHopDong" />
              <Mapping SourceColumn="dNghiHuu" DataSetColumn="dNghiHuu" />
              <Mapping SourceColumn="dKyHopDong" DataSetColumn="dKyHopDong" />
              <Mapping SourceColumn="dModified" DataSetColumn="dModified" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="cGhiChu" DataSetColumn="cGhiChu" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCurrentOnBoardTableAdapter" GeneratorDataComponentClassName="tblCurrentOnBoardTableAdapter" Name="tblCurrentOnBoard" UserDataComponentName="tblCurrentOnBoardTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblAssignment.nAssignmentId, tblAssignment.nCrewid, tblAssignment.nVesselId, tblAssignment.cStatus, tblAssignment.cDescription, tblAssignment.dEmbarked, 
                         tblAssignment.nContract, tblAssignment.dLeave, tblAssignment.nRequest, tblAssignment.dDuKienRoiTau, tblAssignment.dSanSangLenTau, 
                         tblAssignment.dCatHopDong, tblAssignment.dNghiHuu, tblAssignment.dKyHopDong, tblAssignment.dModified, tblAssignment.isActive, tblAssignment.cGhiChu, 
                         tblCrew.nRankID, tblCrew.cFamilyName, tblCrew.cMiddleName, tblCrew.cFirstName, tblVessel.cVesselName, tblVessel.cShortName

FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId INNER JOIN
                         tblVessel ON tblAssignment.nVesselId = tblVessel.nVesselId
WHERE        (tblAssignment.isActive = 1) AND (tblAssignment.cStatus = 'On Board')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nAssignmentId" DataSetColumn="nAssignmentId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="dSanSangLenTau" DataSetColumn="dSanSangLenTau" />
              <Mapping SourceColumn="dCatHopDong" DataSetColumn="dCatHopDong" />
              <Mapping SourceColumn="dNghiHuu" DataSetColumn="dNghiHuu" />
              <Mapping SourceColumn="dKyHopDong" DataSetColumn="dKyHopDong" />
              <Mapping SourceColumn="dModified" DataSetColumn="dModified" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
              <Mapping SourceColumn="cGhiChu" DataSetColumn="cGhiChu" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
              <Mapping SourceColumn="cShortName" DataSetColumn="cShortName" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsAssignment" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsAssignment" msprop:Generator_UserDSName="dsAssignment">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblAssignment" msprop:Generator_TableClassName="tblAssignmentDataTable" msprop:Generator_TableVarName="tabletblAssignment" msprop:Generator_TablePropName="tblAssignment" msprop:Generator_RowDeletingName="tblAssignmentRowDeleting" msprop:Generator_UserTableName="tblAssignment" msprop:Generator_RowChangingName="tblAssignmentRowChanging" msprop:Generator_RowEvHandlerName="tblAssignmentRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAssignmentRowDeleted" msprop:Generator_RowEvArgName="tblAssignmentRowChangeEvent" msprop:Generator_RowChangedName="tblAssignmentRowChanged" msprop:Generator_RowClassName="tblAssignmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nAssignmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnAssignmentId" msprop:Generator_ColumnPropNameInRow="nAssignmentId" msprop:Generator_ColumnPropNameInTable="nAssignmentIdColumn" msprop:Generator_UserColumnName="nAssignmentId" type="xs:int" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dSanSangLenTau" msprop:Generator_ColumnVarNameInTable="columndSanSangLenTau" msprop:Generator_ColumnPropNameInRow="dSanSangLenTau" msprop:Generator_ColumnPropNameInTable="dSanSangLenTauColumn" msprop:Generator_UserColumnName="dSanSangLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dCatHopDong" msprop:Generator_ColumnVarNameInTable="columndCatHopDong" msprop:Generator_ColumnPropNameInRow="dCatHopDong" msprop:Generator_ColumnPropNameInTable="dCatHopDongColumn" msprop:Generator_UserColumnName="dCatHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dNghiHuu" msprop:Generator_ColumnVarNameInTable="columndNghiHuu" msprop:Generator_ColumnPropNameInRow="dNghiHuu" msprop:Generator_ColumnPropNameInTable="dNghiHuuColumn" msprop:Generator_UserColumnName="dNghiHuu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dKyHopDong" msprop:Generator_ColumnVarNameInTable="columndKyHopDong" msprop:Generator_ColumnPropNameInRow="dKyHopDong" msprop:Generator_ColumnPropNameInTable="dKyHopDongColumn" msprop:Generator_UserColumnName="dKyHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dModified" msprop:Generator_ColumnVarNameInTable="columndModified" msprop:Generator_ColumnPropNameInRow="dModified" msprop:Generator_ColumnPropNameInTable="dModifiedColumn" msprop:Generator_UserColumnName="dModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="cGhiChu" msprop:Generator_ColumnVarNameInTable="columncGhiChu" msprop:Generator_ColumnPropNameInRow="cGhiChu" msprop:Generator_ColumnPropNameInTable="cGhiChuColumn" msprop:Generator_UserColumnName="cGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCurrentOnBoard" msprop:Generator_TableClassName="tblCurrentOnBoardDataTable" msprop:Generator_TableVarName="tabletblCurrentOnBoard" msprop:Generator_TablePropName="tblCurrentOnBoard" msprop:Generator_RowDeletingName="tblCurrentOnBoardRowDeleting" msprop:Generator_UserTableName="tblCurrentOnBoard" msprop:Generator_RowChangingName="tblCurrentOnBoardRowChanging" msprop:Generator_RowEvHandlerName="tblCurrentOnBoardRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCurrentOnBoardRowDeleted" msprop:Generator_RowEvArgName="tblCurrentOnBoardRowChangeEvent" msprop:Generator_RowChangedName="tblCurrentOnBoardRowChanged" msprop:Generator_RowClassName="tblCurrentOnBoardRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nAssignmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnAssignmentId" msprop:Generator_ColumnPropNameInRow="nAssignmentId" msprop:Generator_ColumnPropNameInTable="nAssignmentIdColumn" msprop:Generator_UserColumnName="nAssignmentId" type="xs:int" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dSanSangLenTau" msprop:Generator_ColumnVarNameInTable="columndSanSangLenTau" msprop:Generator_ColumnPropNameInRow="dSanSangLenTau" msprop:Generator_ColumnPropNameInTable="dSanSangLenTauColumn" msprop:Generator_UserColumnName="dSanSangLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dCatHopDong" msprop:Generator_ColumnVarNameInTable="columndCatHopDong" msprop:Generator_ColumnPropNameInRow="dCatHopDong" msprop:Generator_ColumnPropNameInTable="dCatHopDongColumn" msprop:Generator_UserColumnName="dCatHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dNghiHuu" msprop:Generator_ColumnVarNameInTable="columndNghiHuu" msprop:Generator_ColumnPropNameInRow="dNghiHuu" msprop:Generator_ColumnPropNameInTable="dNghiHuuColumn" msprop:Generator_UserColumnName="dNghiHuu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dKyHopDong" msprop:Generator_ColumnVarNameInTable="columndKyHopDong" msprop:Generator_ColumnPropNameInRow="dKyHopDong" msprop:Generator_ColumnPropNameInTable="dKyHopDongColumn" msprop:Generator_UserColumnName="dKyHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dModified" msprop:Generator_ColumnVarNameInTable="columndModified" msprop:Generator_ColumnPropNameInRow="dModified" msprop:Generator_ColumnPropNameInTable="dModifiedColumn" msprop:Generator_UserColumnName="dModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
              <xs:element name="cGhiChu" msprop:Generator_ColumnVarNameInTable="columncGhiChu" msprop:Generator_ColumnPropNameInRow="cGhiChu" msprop:Generator_ColumnPropNameInTable="cGhiChuColumn" msprop:Generator_UserColumnName="cGhiChu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="cFamilyName+ ' ' + cMiddleName + ' ' + cFirstName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" type="xs:string" minOccurs="0" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cShortName" msprop:Generator_ColumnVarNameInTable="columncShortName" msprop:Generator_ColumnPropNameInRow="cShortName" msprop:Generator_ColumnPropNameInTable="cShortNameColumn" msprop:Generator_UserColumnName="cShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Subject" msdata:ReadOnly="true" msdata:Expression="FullName + ' (' + nContract + ') ' + cShortName" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignment" />
      <xs:field xpath="mstns:nAssignmentId" />
    </xs:unique>
    <xs:unique name="tblCurrentOnBoard_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCurrentOnBoard" />
      <xs:field xpath="mstns:nAssignmentId" />
    </xs:unique>
  </xs:element>
</xs:schema>